package com.attendance.mapper;

import com.attendance.vo.ExaminehomeworkVO;
import com.attendance.vo.ExamineworkSituationVO;
import com.attendance.vo.HomeWorkVO;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 *
 * 作业表Dao层
 *
 **/

@Repository
public interface HomeworkMapper {
    int insertHomework(HomeWorkVO homeWorkVO);
    int selectCourseId(HomeWorkVO homeWorkVO);
    int selectProjectGroup(HomeWorkVO homeWorkVO);
    int selectStuId(HomeWorkVO homeWorkVO);
    int insertStudentHomework(HomeWorkVO homeWorkVO);
    int insertPGC(HomeWorkVO homeWorkVO);
    int insertStuHomework(HomeWorkVO homeWorkVO);

    List<HomeWorkVO> SelectAllWork();

    List<HomeWorkVO> SelectAllWorkByHomId(Integer homId);

    List<HomeWorkVO> SelectStuHomeworkByDY(HomeWorkVO homeWorkVO);

    List<ExaminehomeworkVO>  SelectExaminehomeworkByConditionDT(ExaminehomeworkVO examinehomeworkVO);

    int DeleteHomeworkByHomId(int homId);

    int UpdateExaminehomeworkByhomId(int homId,Float homeScore,String teaComment);

    List<ExaminehomeworkVO> SelectworkTastByhomIdOrteaIdDT(int teaId);

    List<ExaminehomeworkVO> SelectworkTastByhomIdOrteaIdDT();

    List<ExaminehomeworkVO> SelectshJobContentByhomIdORstuId(int stuId);

    List<ExamineworkSituationVO> SelectAllExamineworkSituation();

    int UpdateShJobContentByHomIdOrStuId(String shJobContent,int homId,int stuId);
}
